package com.kcyu.sfherp.mapper.ms;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kcyu.sfherp.entity.CustomHistoryPrice;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface CustomHistoryPriceMapper extends BaseMapper<CustomHistoryPrice> {

    @Select("select top 20 khname as 'khname',spname,spbh,prnjs,prnxs,jg,jj,je,rq from chmx where khname like '%${khname}%' and spname like '%${spname}%' ORDER BY rq desc")
    public List<CustomHistoryPrice> getCustomHistoryPrice(String khname,String spname);
}
